PRODUCTION

Dump file /prod/oraprod/proddb/8.1.7/admin/PROD_tmdb1/udump/ora_22435_prod.trc
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production
ORACLE_HOME = /prod/oraprod/proddb/8.1.7
System name:	HP-UX
Node name:	tmdb1
Release:	B.11.11
Version:	U
Machine:	9000/800
Instance name: PROD
Redo thread mounted by this instance: 1
Oracle process number: 65
Unix process pid: 22435, image: oracle@tmdb1 (TNS V1-V3)

*** 2007-11-01 12:50:56.847
*** SESSION ID:(76.581) 2007-11-01 12:50:56.845
APPNAME mod='POXRQVRQ' mh=3767490299 act='Online-Tm Purchasing Super Us' ah=835828768
=====================
PARSING IN CURSOR #97 len=32 dep=0 uid=183 oct=42 lid=183 tim=3425148692 hv=1197935484 ad='8ef616a0'
alter session set sql_trace=true
END OF STMT
EXEC #97:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425148692
=====================
PARSING IN CURSOR #97 len=39 dep=0 uid=183 oct=42 lid=183 tim=3425148692 hv=2463866144 ad='8ef6ce48'
alter session set timed_statistics=true
END OF STMT
PARSE #97:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425148692
EXEC #97:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425148692
=====================
PARSING IN CURSOR #96 len=105 dep=0 uid=183 oct=47 lid=183 tim=3425148693 hv=2108922784 ad='99c67420'
declare dummy boolean;begin fnd_profile.get_specific(:name, :userid, :respid,  :applid, :val, dummy);end;
END OF STMT
PARSE #96:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425148693
=====================
PARSING IN CURSOR #10 len=185 dep=1 uid=183 oct=3 lid=183 tim=3425148693 hv=2924380235 ad='99c656b0'
SELECT PROFILE_OPTION_ID,APPLICATION_ID   FROM FND_PROFILE_OPTIONS  WHERE PROFILE_OPTION_NAME = UPPER(:b1)  AND START_DATE_ACTIVE <= SYSDATE  AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
END OF STMT
EXEC #10:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
FETCH #10:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=3425148693
=====================
PARSING IN CURSOR #12 len=160 dep=1 uid=183 oct=3 lid=183 tim=3425148693 hv=373737229 ad='99c627e0'
SELECT PROFILE_OPTION_VALUE   FROM FND_PROFILE_OPTION_VALUES  WHERE PROFILE_OPTION_ID = :b1  AND APPLICATION_ID = :b2  AND LEVEL_ID = :b3  AND LEVEL_VALUE = :b4
END OF STMT
EXEC #12:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
FETCH #12:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
=====================
PARSING IN CURSOR #13 len=200 dep=1 uid=183 oct=3 lid=183 tim=3425148693 hv=2622125724 ad='99c625e8'
SELECT PROFILE_OPTION_VALUE   FROM FND_PROFILE_OPTION_VALUES  WHERE PROFILE_OPTION_ID = :b1  AND APPLICATION_ID = :b2  AND LEVEL_ID = 10003  AND LEVEL_VALUE = :b3  AND LEVEL_VALUE_APPLICATION_ID = :b4
END OF STMT
EXEC #13:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
FETCH #13:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
EXEC #12:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
FETCH #12:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
EXEC #12:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425148693
FETCH #12:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=3425148693
EXEC #96:c=0,e=0,p=0,cr=12,cu=0,mis=0,r=1,dep=0,og=4,tim=3425148693



### Start ###
*** 2007-11-01 12:51:46.448
=====================
PARSING IN CURSOR #24 len=187 dep=1 uid=183 oct=3 lid=183 tim=3425153652 hv=1830909701 ad='98b36308'
SELECT HOI.ORG_INFORMATION_CONTEXT,HOI.ORG_INFORMATION1   FROM HR_ORGANIZATION_INFORMATION HOI  WHERE HOI.ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_INFORMATION'  AND HOI.ORGANIZATION_ID = :b1
END OF STMT
EXEC #24:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153652
FETCH #24:c=0,e=0,p=0,cr=4,cu=4,mis=0,r=0,dep=1,og=4,tim=3425153652
=====================
PARSING IN CURSOR #27 len=100 dep=1 uid=183 oct=3 lid=183 tim=3425153653 hv=2539484203 ad='98b1a8a8'
SELECT COUNT(*)   FROM FV_OPERATING_UNITS_ALL  WHERE ORGANIZATION_ID = NVL(:b1,0)  AND ENABLED = 'Y'
END OF STMT
EXEC #27:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #27:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=3425153653
=====================
PARSING IN CURSOR #28 len=190 dep=1 uid=183 oct=3 lid=183 tim=3425153653 hv=885722162 ad='98b0a470'
(SELECT STATUS_FLAG   FROM IGI_GCC_INSTALLED_OPTIONS  WHERE UPPER(OPTION_NAME) = UPPER(:b1) ) UNION (SELECT STATUS_FLAG   FROM IGI_GCC_GL_FA_INST_OPS  WHERE UPPER(OPTION_NAME) = UPPER(:b1) )
END OF STMT
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=0,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=0,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=0,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=0,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=0,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=0,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
=====================
PARSING IN CURSOR #98 len=64 dep=1 uid=183 oct=3 lid=183 tim=3425153653 hv=1432353491 ad='98afddd8'
 SELECT COUNT(*)  FROM   igc_cc_routing_ctrls WHERE  org_id = 82
END OF STMT
PARSE #98:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
EXEC #98:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #98:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=3425153653
STAT #98 id=1 cnt=1 pid=0 pos=0 obj=0 op='SORT AGGREGATE '
STAT #98 id=2 cnt=0 pid=1 pos=1 obj=169040 op='INDEX RANGE SCAN '
EXEC #28:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #28:c=1,e=0,p=0,cr=5,cu=8,mis=0,r=1,dep=1,og=4,tim=3425153653
=====================
PARSING IN CURSOR #29 len=86 dep=1 uid=183 oct=3 lid=183 tim=3425153653 hv=988596303 ad='98adf518'
SELECT STATUS   FROM PSA_IMPLEMENTATION_ALL  WHERE ORG_ID = :b1  AND PSA_FEATURE = :b2
END OF STMT
EXEC #29:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153653
FETCH #29:c=0,e=0,p=0,cr=0,cu=4,mis=0,r=0,dep=1,og=4,tim=3425153653
=====================
PARSING IN CURSOR #21 len=345 dep=1 uid=183 oct=3 lid=183 tim=3425153654 hv=1038430954 ad='99604ad8'
SELECT FPI.STATUS,FPI.INDUSTRY,FPI.PRODUCT_VERSION,FOU.ORACLE_USERNAME,FPI.TABLESPACE,FPI.INDEX_TABLESPACE,FPI.TEMPORARY_TABLESPACE,FPI.SIZING_FACTOR   FROM FND_PRODUCT_INSTALLATIONS FPI,FND_ORACLE_USERID FOU,FND_APPLICATION FA  WHERE FPI.APPLICATION_ID = FA.APPLICATION_ID  AND FPI.ORACLE_ID = FOU.ORACLE_ID  AND FA.APPLICATION_SHORT_NAME = :b1
END OF STMT
EXEC #21:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153654
FETCH #21:c=0,e=0,p=0,cr=6,cu=0,mis=0,r=1,dep=1,og=4,tim=3425153654
FETCH #21:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153654

THE TRACE START DIFFERENT IN BELOW PORTION COMPARE WITH HLD ENVIRONMENT.
PARSING IN CURSOR #98 len=755 dep=1 uid=183 oct=3 lid=183 tim=3425153656 hv=2888308366 ad='949dab20'
SELECT COUNT(1)   FROM PO_DOCUMENT_TYPES PODT  WHERE PODT.DOCUMENT_TYPE_CODE = :b1  AND PODT.DOCUMENT_SUBTYPE = :b2  AND (:b3 = :b4  OR (PODT.SECURITY_LEVEL_CODE = 'PUBLIC'  AND PODT.ACCESS_LEVEL_CODE = 'FULL' ) OR (PODT.SECURITY_LEVEL_CODE = 'PURCHASING'  AND PODT.ACCESS_LEVEL_CODE = 'FULL'  AND EXISTS  (SELECT 'Is the user an agent'   FROM PO_AGENTS POA  WHERE POA.AGENT_ID = :b4  AND SYSDATE BETWEEN POA.START_DATE_ACTIVE AND NVL(POA.END_DATE_ACTIVE,SYSDATE + 1 ) ) ) OR (PODT.SECURITY_LEVEL_CODE = 'HIERARCHY'  AND PODT.ACCESS_LEVEL_CODE = 'FULL'  AND :b4 IN (SELECT POEH.SUPERIOR_ID   FROM PO_EMPLOYEE_HIERARCHIES POEH,PO_SYSTEM_PARAMETERS POSP  WHERE POEH.EMPLOYEE_ID = :b3  AND POEH.POSITION_STRUCTURE_ID = POSP.SECURITY_POSITION_STRUCTURE_ID )))
END OF STMT
PARSE #98:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153656
EXEC #98:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153656
FETCH #98:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,tim=3425153656
=====================
PARSING IN CURSOR #99 len=259 dep=1 uid=183 oct=3 lid=183 tim=3425153656 hv=809191618 ad='8ce7f460'
SELECT DISTINCT POLC.DISPLAYED_FIELD,PORH.AUTHORIZATION_STATUS   FROM PO_LOOKUP_CODES POLC,PO_REQUISITION_HEADERS_ALL PORH  WHERE PORH.AUTHORIZATION_STATUS = POLC.LOOKUP_CODE  AND POLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS'  AND PORH.REQUISITION_HEADER_ID = :b1
END OF STMT
PARSE #99:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153656
EXEC #99:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153656
FETCH #99:c=0,e=0,p=0,cr=7,cu=0,mis=0,r=1,dep=1,og=4,tim=3425153656
=====================
PARSING IN CURSOR #100 len=1324 dep=0 uid=183 oct=3 lid=183 tim=3425153656 hv=1465782085 ad='8ec92988'
SELECT POLC.displayed_field, POLC.lookup_code FROM PO_LOOKUP_CODES POLC, PO_REQUISITION_LINES PORL WHERE PORL.requisition_line_id = 73757 AND nvl(PORL.closed_code, 'OPEN') not in ('FINALLY CLOSED') AND nvl(PORL.cancel_flag, 'N') IN ('N','I') AND POLC.LOOKUP_TYPE = 'CONTROL ACTIONS' AND ((POLC.lookup_code in ('CANCEL REQ LINE', 'FINALLY CLOSE') AND (NOT EXISTS (SELECT 'need a so_line is not cancelled' FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS PORH, PO_SYSTEM_PARAMETERS POSP WHERE PORH.requisition_header_id = 27459 AND PORL.requisition_line_id = 73757 AND PORH.requisition_header_id = PORL.requisition_header_id AND (OE_ORDER_IMPORT_INTEROP_PUB.Get_Open_Qty(POSP.order_source_id, PORH.requisition_header_id, PORL.requisition_line_id))>0) AND NOT EXISTS ( SELECT 'Check for lines in the interface table' FROM oe_lines_iface_all SOLI, po_system_parameters POSP, po_requisition_lines PORL, po_requisition_headers PORH WHERE PORH.requisition_header_id = 27459 AND PORL.requisition_line_id = 73757 AND PORH.requisition_header_id = PORL.requisition_header_id AND SOLI.orig_sys_document_ref = PORH.requisition_header_id AND SOLI.orig_sys_line_ref = PORL.requisition_line_id AND SOLI.order_source_id = to_char(POSP.order_source_id))) /* OR (POLC.lookup_code in ('FINALLY CLOSE')) */ )) ORDER BY POLC.displayed_field
END OF STMT
PARSE #100:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425153656
=====================
PARSING IN CURSOR #100 len=1324 dep=0 uid=183 oct=3 lid=183 tim=3425153658 hv=1465782085 ad='8ec92988'
SELECT POLC.displayed_field, POLC.lookup_code FROM PO_LOOKUP_CODES POLC, PO_REQUISITION_LINES PORL WHERE PORL.requisition_line_id = 73757 AND nvl(PORL.closed_code, 'OPEN') not in ('FINALLY CLOSED') AND nvl(PORL.cancel_flag, 'N') IN ('N','I') AND POLC.LOOKUP_TYPE = 'CONTROL ACTIONS' AND ((POLC.lookup_code in ('CANCEL REQ LINE', 'FINALLY CLOSE') AND (NOT EXISTS (SELECT 'need a so_line is not cancelled' FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS PORH, PO_SYSTEM_PARAMETERS POSP WHERE PORH.requisition_header_id = 27459 AND PORL.requisition_line_id = 73757 AND PORH.requisition_header_id = PORL.requisition_header_id AND (OE_ORDER_IMPORT_INTEROP_PUB.Get_Open_Qty(POSP.order_source_id, PORH.requisition_header_id, PORL.requisition_line_id))>0) AND NOT EXISTS ( SELECT 'Check for lines in the interface table' FROM oe_lines_iface_all SOLI, po_system_parameters POSP, po_requisition_lines PORL, po_requisition_headers PORH WHERE PORH.requisition_header_id = 27459 AND PORL.requisition_line_id = 73757 AND PORH.requisition_header_id = PORL.requisition_header_id AND SOLI.orig_sys_document_ref = PORH.requisition_header_id AND SOLI.orig_sys_line_ref = PORL.requisition_line_id AND SOLI.order_source_id = to_char(POSP.order_source_id))) /* OR (POLC.lookup_code in ('FINALLY CLOSE')) */ )) ORDER BY POLC.displayed_field
END OF STMT
PARSE #100:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425153658
EXEC #100:c=0,e=0,p=0,cr=8,cu=0,mis=0,r=0,dep=0,og=4,tim=3425153658
ERROR #100:err=1722 tim=3425153658
=====================
PARSING IN CURSOR #19 len=207 dep=1 uid=183 oct=3 lid=183 tim=3425153658 hv=230226944 ad='99c856c8'
SELECT MESSAGE_TEXT   FROM FND_NEW_MESSAGES M,FND_APPLICATION A  WHERE :b1 = M.MESSAGE_NAME  AND M.LANGUAGE_CODE = USERENV('LANG')  AND :b2 = A.APPLICATION_SHORT_NAME  AND M.APPLICATION_ID = A.APPLICATION_ID
END OF STMT
EXEC #19:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3425153658
FETCH #19:c=0,e=0,p=0,cr=6,cu=0,mis=0,r=1,dep=1,og=4,tim=3425153658
=====================
PARSING IN CURSOR #96 len=41 dep=0 uid=183 oct=47 lid=183 tim=3425153659 hv=3516892884 ad='961bcc80'
begin FND_MESSAGE.RETRIEVE(:result); end;
END OF STMT
PARSE #96:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3425153659
EXEC #96:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=3425153659
